
use [StaffIntranetTesting]

insert into Staff values ('Bloggs', 'Joe', 'G', 'joe@foobar.com', '01212 656484', '6484',1, 'bloggs photo data')
insert into Staff values ('Doe', 'John', 'Bob', 'john@initech.com', '03212 877784', '7784',4, 'doe photo data')
insert into Staff values ('Black', 'Jill', 'Sue', 'jill@somewhere.com', '08711 744562', '4562',1, 'black photo data')
insert into Staff values ('Fisco', 'Bob', 'Henry', 'bob@saitek.com', '046457 899947', '9947',2, 'fisco photo data')
